Dataset statistics
| Number of variables | 53 |
|---|---|
| Number of observations | 180519 |
| Missing cells | 336209 |
| Missing cells (%) | 3.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 333.7 MiB |
| Average record size in memory | 1.9 KiB |
Variable types
| NUM | 25 |
|---|---|
| CAT | 24 |
| BOOL | 2 |
| URL | 1 |
| UNSUPPORTED | 1 |
Reproduction
| Analysis started | 2020-04-08 07:35:13.153937 |
|---|---|
| Analysis finished | 2020-04-08 07:54:11.098164 |
| Version | pandas-profiling v2.5.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Customer City has a high cardinality: 563 distinct values | High cardinality |
Customer Fname has a high cardinality: 782 distinct values | High cardinality |
Customer Lname has a high cardinality: 1109 distinct values | High cardinality |
Customer Street has a high cardinality: 7458 distinct values | High cardinality |
Order City has a high cardinality: 3597 distinct values | High cardinality |
Order Country has a high cardinality: 164 distinct values | High cardinality |
order date (DateOrders) has a high cardinality: 65752 distinct values | High cardinality |
Order State has a high cardinality: 1089 distinct values | High cardinality |
Product Name has a high cardinality: 118 distinct values | High cardinality |
shipping date (DateOrders) has a high cardinality: 63701 distinct values | High cardinality |
Longitude is highly correlated with Customer Zipcode | High Correlation |
Customer Zipcode is highly correlated with Longitude | High Correlation |
Order Customer Id is highly correlated with Customer Id | High Correlation |
Customer Id is highly correlated with Order Customer Id | High Correlation |
Order Item Cardprod Id is highly correlated with Category Id and 3 other fields | High Correlation |
Category Id is highly correlated with Order Item Cardprod Id and 2 other fields | High Correlation |
Department Id is highly correlated with Order Item Cardprod Id and 1 other fields | High Correlation |
Order Item Id is highly correlated with Order Id | High Correlation |
Order Id is highly correlated with Order Item Id | High Correlation |
Sales is highly correlated with Sales per customer and 1 other fields | High Correlation |
Sales per customer is highly correlated with Sales and 1 other fields | High Correlation |
Order Item Total is highly correlated with Sales per customer and 1 other fields | High Correlation |
Order Profit Per Order is highly correlated with Benefit per order | High Correlation |
Benefit per order is highly correlated with Order Profit Per Order | High Correlation |
Product Card Id is highly correlated with Category Id and 3 other fields | High Correlation |
Product Category Id is highly correlated with Category Id and 2 other fields | High Correlation |
Product Price is highly correlated with Order Item Product Price | High Correlation |
Order Item Product Price is highly correlated with Product Price | High Correlation |
Customer State is highly correlated with Customer Country | High Correlation |
Customer Country is highly correlated with Customer State | High Correlation |
Department Name is highly correlated with Category Name | High Correlation |
Category Name is highly correlated with Department Name | High Correlation |
Order Region is highly correlated with Market | High Correlation |
Market is highly correlated with Order Region | High Correlation |
Order Status is highly correlated with Type | High Correlation |
Type is highly correlated with Order Status | High Correlation |
Shipping Mode is highly correlated with Days for shipment (scheduled) | High Correlation |
Days for shipment (scheduled) is highly correlated with Shipping Mode | High Correlation |
Order Zipcode has 155679 (86.2%) missing values | Missing |
Product Description has 180519 (100.0%) missing values | Missing |
Product Description is an unsupported type, check if it needs cleaning or further analysis | Rejected |
Days for shipping (real) has 5080 (2.8%) zeros | Zeros |
Order Item Discount has 10028 (5.6%) zeros | Zeros |
Order Item Discount Rate has 10028 (5.6%) zeros | Zeros |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| DEBIT | |
|---|---|
| TRANSFER | |
| PAYMENT | |
| CASH |
| Value | Count | Frequency (%) | |
| DEBIT | 69295 | 38.4% | |
| TRANSFER | 49883 | 27.6% | |
| PAYMENT | 41725 | 23.1% | |
| CASH | 19616 | 10.9% |
Length
| Max length | 8 |
|---|---|
| Mean length | 6.182606817 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 15 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 15 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.497653987 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros | 5080 |
| Zeros (%) | 2.8% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.623721828 |
|---|---|
| Coefficient of variation (CV) | 0.464231692 |
| Kurtosis | -1.007913583 |
| Mean | 3.497653987 |
| Median Absolute Deviation (MAD) | 1.423770874 |
| Skewness | 0.084771273 |
| Sum | 631393 |
| Variance | 2.636472576 |
| Value | Count | Frequency (%) | |
| 2 | 56618 | 31.4% | |
| 3 | 28765 | 15.9% | |
| 6 | 28723 | 15.9% | |
| 4 | 28513 | 15.8% | |
| 5 | 28163 | 15.6% | |
| 0 | 5080 | 2.8% | |
| 1 | 4657 | 2.6% |
| Value | Count | Frequency (%) | |
| 0 | 5080 | 2.8% | |
| 1 | 4657 | 2.6% | |
| 2 | 56618 | 31.4% | |
| 3 | 28765 | 15.9% | |
| 4 | 28513 | 15.8% |
| Value | Count | Frequency (%) | |
| 6 | 28723 | 15.9% | |
| 5 | 28163 | 15.6% | |
| 4 | 28513 | 15.8% | |
| 3 | 28765 | 15.9% | |
| 2 | 56618 | 31.4% |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 4 | |
|---|---|
| 2 | |
| 1 | |
| 0 | 9737 |
| Value | Count | Frequency (%) | |
| 4 | 107752 | 59.7% | |
| 2 | 35216 | 19.5% | |
| 1 | 27814 | 15.4% | |
| 0 | 9737 | 5.4% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 4 | 100.0% |
| Distinct count | 21998 |
|---|---|
| Unique (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.97498864 |
|---|---|
| Minimum | -4274.97998 |
| Maximum | 911.7999878 |
| Zeros | 1177 |
| Zeros (%) | 0.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -4274.97998 |
|---|---|
| 5-th percentile | -139.2509994 |
| Q1 | 7 |
| median | 31.52000046 |
| Q3 | 64.80000305 |
| 95-th percentile | 132.2899933 |
| Maximum | 911.7999878 |
| Range | 5186.779968 |
| Interquartile range (IQR) | 57.80000305 |
Descriptive statistics
| Standard deviation | 104.4335257 |
|---|---|
| Coefficient of variation (CV) | 4.752381331 |
| Kurtosis | 71.37725866 |
| Mean | 21.97498864 |
| Median Absolute Deviation (MAD) | 56.08869441 |
| Skewness | -4.74183407 |
| Sum | 3966902.974 |
| Variance | 10906.3613 |
| Value | Count | Frequency (%) | |
| 0 | 1177 | 0.7% | |
| 143.9900055 | 199 | 0.1% | |
| 72 | 194 | 0.1% | |
| 46.79999924 | 188 | 0.1% | |
| 24 | 181 | 0.1% | |
| 18 | 175 | 0.1% | |
| 63.70000076 | 172 | 0.1% | |
| 62.40000153 | 168 | 0.1% | |
| 14.39999962 | 166 | 0.1% | |
| 12 | 166 | 0.1% | |
| Other values (21988) | 177733 | 98.5% |
| Value | Count | Frequency (%) | |
| -4274.97998 | 1 | < 0.1% | |
| -3442.5 | 1 | < 0.1% | |
| -3366 | 1 | < 0.1% | |
| -3000 | 1 | < 0.1% | |
| -2592 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 911.7999878 | 1 | < 0.1% | |
| 864 | 1 | < 0.1% | |
| 721.5999756 | 1 | < 0.1% | |
| 720.2999878 | 1 | < 0.1% | |
| 720 | 2 | < 0.1% |
| Distinct count | 2927 |
|---|---|
| Unique (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 183.1076085 |
|---|---|
| Minimum | 7.489999771 |
| Maximum | 1939.98999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 7.489999771 |
|---|---|
| 5-th percentile | 41.5 |
| Q1 | 104.3799973 |
| median | 163.9900055 |
| Q3 | 247.3999939 |
| 95-th percentile | 383.980011 |
| Maximum | 1939.98999 |
| Range | 1932.49999 |
| Interquartile range (IQR) | 143.0199966 |
Descriptive statistics
| Standard deviation | 120.04367 |
|---|---|
| Coefficient of variation (CV) | 0.6555908354 |
| Kurtosis | 23.92036151 |
| Mean | 183.1076085 |
| Median Absolute Deviation (MAD) | 87.66090517 |
| Skewness | 2.888446057 |
| Sum | 33054402.38 |
| Variance | 14410.48271 |
| Value | Count | Frequency (%) | |
| 122.8399963 | 1264 | 0.7% | |
| 109.1900024 | 1247 | 0.7% | |
| 114.3899994 | 1243 | 0.7% | |
| 113.0899963 | 1243 | 0.7% | |
| 129.9900055 | 1243 | 0.7% | |
| 126.0899963 | 1243 | 0.7% | |
| 107.8899994 | 1243 | 0.7% | |
| 123.4899979 | 1243 | 0.7% | |
| 97.48999786 | 1243 | 0.7% | |
| 110.4899979 | 1243 | 0.7% | |
| Other values (2917) | 168064 | 93.1% |
| Value | Count | Frequency (%) | |
| 7.489999771 | 3 | < 0.1% | |
| 7.989999771 | 3 | < 0.1% | |
| 8.18999958 | 3 | < 0.1% | |
| 8.289999962 | 3 | < 0.1% | |
| 8.390000343 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1939.98999 | 1 | < 0.1% | |
| 1919.98999 | 1 | < 0.1% | |
| 1899.98999 | 1 | < 0.1% | |
| 1889.98999 | 1 | < 0.1% | |
| 1859.98999 | 1 | < 0.1% |
Delivery Status
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Late delivery | |
|---|---|
| Advance shipping | |
| Shipping on time | |
| Shipping canceled | 7754 |
| Value | Count | Frequency (%) | |
| Late delivery | 98977 | 54.8% | |
| Advance shipping | 41592 | 23.0% | |
| Shipping on time | 32196 | 17.8% | |
| Shipping canceled | 7754 | 4.3% |
Length
| Max length | 17 |
|---|---|
| Mean length | 14.39807998 |
| Min length | 13 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 17 | 81.0% | |
| Uppercase_Letter | 3 | 14.3% | |
| Space_Separator | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| Latin | 20 | 95.2% | |
| Common | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| ASCII | 21 | 100.0% |
Late_delivery_risk
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 98977 | 54.8% | |
| 0 | 81542 | 45.2% |
| Distinct count | 51 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.85145054 |
|---|---|
| Minimum | 2 |
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 18 |
| median | 29 |
| Q3 | 45 |
| 95-th percentile | 48 |
| Maximum | 76 |
| Range | 74 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 15.64006388 |
|---|---|
| Coefficient of variation (CV) | 0.4910314481 |
| Kurtosis | -0.6032610083 |
| Mean | 31.85145054 |
| Median Absolute Deviation (MAD) | 13.94913209 |
| Skewness | 0.3616247994 |
| Sum | 5749792 |
| Variance | 244.6115983 |
| Value | Count | Frequency (%) | |
| 17 | 24551 | 13.6% | |
| 18 | 22246 | 12.3% | |
| 24 | 21035 | 11.7% | |
| 46 | 19298 | 10.7% | |
| 45 | 17325 | 9.6% | |
| 48 | 15540 | 8.6% | |
| 43 | 13729 | 7.6% | |
| 9 | 12487 | 6.9% | |
| 29 | 10984 | 6.1% | |
| 37 | 2029 | 1.1% | |
| Other values (41) | 21295 | 11.8% |
| Value | Count | Frequency (%) | |
| 2 | 138 | 0.1% | |
| 3 | 632 | 0.4% | |
| 4 | 67 | < 0.1% | |
| 5 | 343 | 0.2% | |
| 6 | 328 | 0.2% |
| Value | Count | Frequency (%) | |
| 76 | 650 | 0.4% | |
| 75 | 838 | 0.5% | |
| 74 | 529 | 0.3% | |
| 73 | 357 | 0.2% | |
| 72 | 492 | 0.3% |
| Distinct count | 50 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Cleats | |
|---|---|
| Men's Footwear | |
| Women's Apparel | |
| Indoor/Outdoor Games | |
| Fishing | |
| Other values (45) |
| Value | Count | Frequency (%) | |
| Cleats | 24551 | 13.6% | |
| Men's Footwear | 22246 | 12.3% | |
| Women's Apparel | 21035 | 11.7% | |
| Indoor/Outdoor Games | 19298 | 10.7% | |
| Fishing | 17325 | 9.6% | |
| Water Sports | 15540 | 8.6% | |
| Camping & Hiking | 13729 | 7.6% | |
| Cardio Equipment | 12487 | 6.9% | |
| Shop By Sport | 10984 | 6.1% | |
| Electronics | 3156 | 1.7% | |
| Other values (40) | 20168 | 11.2% |
Length
| Max length | 20 |
|---|---|
| Mean length | 12.70779253 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 24 | 49.0% | |
| Uppercase_Letter | 19 | 38.8% | |
| Other_Punctuation | 4 | 8.2% | |
| Dash_Punctuation | 1 | 2.0% | |
| Space_Separator | 1 | 2.0% |
| Value | Count | Frequency (%) | |
| Latin | 43 | 87.8% | |
| Common | 6 | 12.2% |
| Value | Count | Frequency (%) | |
| ASCII | 49 | 100.0% |
| Distinct count | 563 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Caguas | |
|---|---|
| Chicago | 3885 |
| Los Angeles | 3417 |
| Brooklyn | 3412 |
| New York | 1816 |
| Other values (558) |
| Value | Count | Frequency (%) | |
| Caguas | 66770 | 37.0% | |
| Chicago | 3885 | 2.2% | |
| Los Angeles | 3417 | 1.9% | |
| Brooklyn | 3412 | 1.9% | |
| New York | 1816 | 1.0% | |
| Philadelphia | 1577 | 0.9% | |
| Bronx | 1500 | 0.8% | |
| San Diego | 1437 | 0.8% | |
| Miami | 1314 | 0.7% | |
| Houston | 1297 | 0.7% | |
| Other values (553) | 94094 | 52.1% |
Length
| Max length | 20 |
|---|---|
| Mean length | 7.708623469 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 26 | 50.0% | |
| Uppercase_Letter | 25 | 48.1% | |
| Space_Separator | 1 | 1.9% |
| Value | Count | Frequency (%) | |
| Latin | 51 | 98.1% | |
| Common | 1 | 1.9% |
| Value | Count | Frequency (%) | |
| ASCII | 52 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| EE. UU. | |
|---|---|
| Puerto Rico |
| Value | Count | Frequency (%) | |
| EE. UU. | 111146 | 61.6% | |
| Puerto Rico | 69373 | 38.4% |
Length
| Max length | 11 |
|---|---|
| Mean length | 8.537189991 |
| Min length | 7 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 7 | 53.8% | |
| Uppercase_Letter | 4 | 30.8% | |
| Space_Separator | 1 | 7.7% | |
| Other_Punctuation | 1 | 7.7% |
| Value | Count | Frequency (%) | |
| Latin | 11 | 84.6% | |
| Common | 2 | 15.4% |
| Value | Count | Frequency (%) | |
| ASCII | 13 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| XXXXXXXXX |
|---|
| Value | Count | Frequency (%) | |
| XXXXXXXXX | 180519 | 100.0% |
Length
| Max length | 9 |
|---|---|
| Mean length | 9 |
| Min length | 9 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 1 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 1 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 1 | 100.0% |
| Distinct count | 782 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Mary | |
|---|---|
| James | 1835 |
| Robert | 1759 |
| Michael | 1680 |
| David | 1625 |
| Other values (777) |
| Value | Count | Frequency (%) | |
| Mary | 65150 | 36.1% | |
| James | 1835 | 1.0% | |
| Robert | 1759 | 1.0% | |
| Michael | 1680 | 0.9% | |
| David | 1625 | 0.9% | |
| John | 1446 | 0.8% | |
| William | 1365 | 0.8% | |
| Joseph | 1117 | 0.6% | |
| Jennifer | 1033 | 0.6% | |
| Richard | 1032 | 0.6% | |
| Other values (772) | 102477 | 56.8% |
Length
| Max length | 11 |
|---|---|
| Mean length | 5.274658069 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 26 | 50.0% | |
| Uppercase_Letter | 26 | 50.0% |
| Value | Count | Frequency (%) | |
| Latin | 52 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 52 | 100.0% |
| Distinct count | 20652 |
|---|---|
| Unique (%) | 11.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6691.379495 |
|---|---|
| Minimum | 1 |
| Maximum | 20757 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 649 |
| Q1 | 3258.5 |
| median | 6457 |
| Q3 | 9779 |
| 95-th percentile | 12383 |
| Maximum | 20757 |
| Range | 20756 |
| Interquartile range (IQR) | 6520.5 |
Descriptive statistics
| Standard deviation | 4162.918106 |
|---|---|
| Coefficient of variation (CV) | 0.6221315215 |
| Kurtosis | 0.01489882226 |
| Mean | 6691.379495 |
| Median Absolute Deviation (MAD) | 3447.119576 |
| Skewness | 0.4887682515 |
| Sum | 1207921135 |
| Variance | 17329887.16 |
| Value | Count | Frequency (%) | |
| 5654 | 47 | < 0.1% | |
| 5004 | 45 | < 0.1% | |
| 10591 | 45 | < 0.1% | |
| 5715 | 44 | < 0.1% | |
| 3708 | 44 | < 0.1% | |
| 9371 | 44 | < 0.1% | |
| 1443 | 43 | < 0.1% | |
| 2641 | 43 | < 0.1% | |
| 791 | 43 | < 0.1% | |
| 12284 | 43 | < 0.1% | |
| Other values (20642) | 180078 | 99.8% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 10 | < 0.1% | |
| 3 | 18 | < 0.1% | |
| 4 | 14 | < 0.1% | |
| 5 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 20757 | 1 | < 0.1% | |
| 20756 | 1 | < 0.1% | |
| 20755 | 1 | < 0.1% | |
| 20754 | 1 | < 0.1% | |
| 20753 | 1 | < 0.1% |
| Distinct count | 1109 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 8 |
| Missing (%) | < 0.1% |
| Memory size | 1.4 MiB |
| Smith | |
|---|---|
| Johnson | 989 |
| Brown | 909 |
| Williams | 869 |
| Jones | 859 |
| Other values (1104) |
| Value | Count | Frequency (%) | |
| Smith | 64104 | 35.5% | |
| Johnson | 989 | 0.5% | |
| Brown | 909 | 0.5% | |
| Williams | 869 | 0.5% | |
| Jones | 859 | 0.5% | |
| Garcia | 724 | 0.4% | |
| Wilson | 675 | 0.4% | |
| Taylor | 661 | 0.4% | |
| Davis | 640 | 0.4% | |
| Moore | 599 | 0.3% | |
| Other values (1099) | 109482 | 60.6% |
Length
| Max length | 12 |
|---|---|
| Mean length | 5.712290673 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 26 | 51.0% | |
| Uppercase_Letter | 25 | 49.0% |
| Value | Count | Frequency (%) | |
| Latin | 51 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 51 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| XXXXXXXXX |
|---|
| Value | Count | Frequency (%) | |
| XXXXXXXXX | 180519 | 100.0% |
Length
| Max length | 9 |
|---|---|
| Mean length | 9 |
| Min length | 9 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 1 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 1 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 1 | 100.0% |
Customer Segment
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
| Value | Count | Frequency (%) | |
| Consumer | 93504 | 51.8% | |
| Corporate | 54789 | 30.4% | |
| Home Office | 32226 | 17.9% |
Length
| Max length | 11 |
|---|---|
| Mean length | 8.839064032 |
| Min length | 8 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 13 | 76.5% | |
| Uppercase_Letter | 3 | 17.6% | |
| Space_Separator | 1 | 5.9% |
| Value | Count | Frequency (%) | |
| Latin | 16 | 94.1% | |
| Common | 1 | 5.9% |
| Value | Count | Frequency (%) | |
| ASCII | 17 | 100.0% |
| Distinct count | 46 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| PR | |
|---|---|
| CA | |
| NY | 11327 |
| TX | 9103 |
| IL | 7631 |
| Other values (41) |
| Value | Count | Frequency (%) | |
| PR | 69373 | 38.4% | |
| CA | 29223 | 16.2% | |
| NY | 11327 | 6.3% | |
| TX | 9103 | 5.0% | |
| IL | 7631 | 4.2% | |
| FL | 5456 | 3.0% | |
| OH | 4095 | 2.3% | |
| PA | 3824 | 2.1% | |
| MI | 3804 | 2.1% | |
| NJ | 3191 | 1.8% | |
| Other values (36) | 33492 | 18.6% |
Length
| Max length | 5 |
|---|---|
| Mean length | 2.000049856 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 24 | 77.4% | |
| Decimal_Number | 7 | 22.6% |
| Value | Count | Frequency (%) | |
| Latin | 24 | 77.4% | |
| Common | 7 | 22.6% |
| Value | Count | Frequency (%) | |
| ASCII | 31 | 100.0% |
| Distinct count | 7458 |
|---|---|
| Unique (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 9126 Wishing Expressway | 122 |
|---|---|
| 4388 Burning Goose Ridge | 117 |
| 4720 Noble Hills Wynd | 116 |
| 2878 Hazy Wagon Thicket | 113 |
| 398 Emerald Grove | 109 |
| Other values (7453) |
| Value | Count | Frequency (%) | |
| 9126 Wishing Expressway | 122 | 0.1% | |
| 4388 Burning Goose Ridge | 117 | 0.1% | |
| 4720 Noble Hills Wynd | 116 | 0.1% | |
| 2878 Hazy Wagon Thicket | 113 | 0.1% | |
| 398 Emerald Grove | 109 | 0.1% | |
| 3593 Blue Brook Acres | 108 | 0.1% | |
| 6289 Rocky Way | 107 | 0.1% | |
| 2210 Merry Leaf Row | 107 | 0.1% | |
| 2585 Silent Autumn Landing | 105 | 0.1% | |
| 141 Dewy Plaza | 103 | 0.1% | |
| Other values (7448) | 179412 | 99.4% |
Length
| Max length | 33 |
|---|---|
| Mean length | 19.95711255 |
| Min length | 8 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 25 | 41.0% | |
| Uppercase_Letter | 24 | 39.3% | |
| Decimal_Number | 10 | 16.4% | |
| Dash_Punctuation | 1 | 1.6% | |
| Space_Separator | 1 | 1.6% |
| Value | Count | Frequency (%) | |
| Latin | 49 | 80.3% | |
| Common | 12 | 19.7% |
| Value | Count | Frequency (%) | |
| ASCII | 61 | 100.0% |
| Distinct count | 995 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35921.12691 |
|---|---|
| Minimum | 603 |
| Maximum | 99205 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 603 |
|---|---|
| 5-th percentile | 725 |
| Q1 | 725 |
| median | 19380 |
| Q3 | 78207 |
| 95-th percentile | 94538 |
| Maximum | 99205 |
| Range | 98602 |
| Interquartile range (IQR) | 77482 |
Descriptive statistics
| Standard deviation | 37542.46112 |
|---|---|
| Coefficient of variation (CV) | 1.045135951 |
| Kurtosis | -1.451419372 |
| Mean | 35921.12691 |
| Median Absolute Deviation (MAD) | 34305.8828 |
| Skewness | 0.4908834095 |
| Sum | 6484338146 |
| Variance | 1409436387 |
| Value | Count | Frequency (%) | |
| 725 | 66770 | 37.0% | |
| 921 | 337 | 0.2% | |
| 23455 | 334 | 0.2% | |
| 957 | 297 | 0.2% | |
| 79109 | 292 | 0.2% | |
| 33324 | 283 | 0.2% | |
| 80012 | 280 | 0.2% | |
| 33624 | 261 | 0.1% | |
| 92115 | 256 | 0.1% | |
| 92024 | 254 | 0.1% | |
| Other values (985) | 111152 | 61.6% |
| Value | Count | Frequency (%) | |
| 603 | 50 | < 0.1% | |
| 612 | 122 | 0.1% | |
| 674 | 169 | 0.1% | |
| 680 | 133 | 0.1% | |
| 685 | 126 | 0.1% |
| Value | Count | Frequency (%) | |
| 99205 | 43 | < 0.1% | |
| 98632 | 67 | < 0.1% | |
| 98390 | 28 | < 0.1% | |
| 98226 | 47 | < 0.1% | |
| 98208 | 95 | 0.1% |
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.443460245 |
|---|---|
| Minimum | 2 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 5 |
| Q3 | 7 |
| 95-th percentile | 7 |
| Maximum | 12 |
| Range | 10 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.629246035 |
|---|---|
| Coefficient of variation (CV) | 0.2993033772 |
| Kurtosis | -0.1816965071 |
| Mean | 5.443460245 |
| Median Absolute Deviation (MAD) | 1.43459705 |
| Skewness | 0.2733206291 |
| Sum | 982648 |
| Variance | 2.654442643 |
| Value | Count | Frequency (%) | |
| 7 | 66861 | 37.0% | |
| 4 | 48998 | 27.1% | |
| 5 | 33220 | 18.4% | |
| 3 | 14525 | 8.0% | |
| 6 | 9686 | 5.4% | |
| 2 | 2479 | 1.4% | |
| 9 | 2026 | 1.1% | |
| 10 | 1465 | 0.8% | |
| 11 | 492 | 0.3% | |
| 8 | 405 | 0.2% |
| Value | Count | Frequency (%) | |
| 2 | 2479 | 1.4% | |
| 3 | 14525 | 8.0% | |
| 4 | 48998 | 27.1% | |
| 5 | 33220 | 18.4% | |
| 6 | 9686 | 5.4% |
| Value | Count | Frequency (%) | |
| 12 | 362 | 0.2% | |
| 11 | 492 | 0.3% | |
| 10 | 1465 | 0.8% | |
| 9 | 2026 | 1.1% | |
| 8 | 405 | 0.2% |
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Fan Shop | |
|---|---|
| Apparel | |
| Golf | |
| Footwear | |
| Outdoors | 9686 |
| Other values (6) | 7229 |
| Value | Count | Frequency (%) | |
| Fan Shop | 66861 | 37.0% | |
| Apparel | 48998 | 27.1% | |
| Golf | 33220 | 18.4% | |
| Footwear | 14525 | 8.0% | |
| Outdoors | 9686 | 5.4% | |
| Fitness | 2479 | 1.4% | |
| Discs Shop | 2026 | 1.1% | |
| Technology | 1465 | 0.8% | |
| Pet Shop | 492 | 0.3% | |
| Book Shop | 405 | 0.2% |
Length
| Max length | 18 |
|---|---|
| Mean length | 7.039713271 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 19 | 63.3% | |
| Uppercase_Letter | 10 | 33.3% | |
| Space_Separator | 1 | 3.3% |
| Value | Count | Frequency (%) | |
| Latin | 29 | 96.7% | |
| Common | 1 | 3.3% |
| Value | Count | Frequency (%) | |
| ASCII | 30 | 100.0% |
Latitude
Real number (ℝ)
| Distinct count | 11250 |
|---|---|
| Unique (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.71995466 |
|---|---|
| Minimum | -33.93755341 |
| Maximum | 48.78193283 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -33.93755341 |
|---|---|
| 5-th percentile | 18.21293068 |
| Q1 | 18.26543236 |
| median | 33.14486313 |
| Q3 | 39.27961731 |
| 95-th percentile | 42.39110184 |
| Maximum | 48.78193283 |
| Range | 82.71948624 |
| Interquartile range (IQR) | 21.01418495 |
Descriptive statistics
| Standard deviation | 9.813646327 |
|---|---|
| Coefficient of variation (CV) | 0.3302039468 |
| Kurtosis | -1.555414897 |
| Mean | 29.71995466 |
| Median Absolute Deviation (MAD) | 9.089862493 |
| Skewness | -0.09796266623 |
| Sum | 5365016.496 |
| Variance | 96.30765423 |
| Value | Count | Frequency (%) | |
| 18.2275734 | 417 | 0.2% | |
| 39.49591446 | 370 | 0.2% | |
| 18.22757721 | 300 | 0.2% | |
| 36.91083145 | 280 | 0.2% | |
| 26.0984993 | 270 | 0.1% | |
| 18.38011932 | 267 | 0.1% | |
| 33.04647064 | 234 | 0.1% | |
| 32.75856018 | 218 | 0.1% | |
| 26.21472931 | 218 | 0.1% | |
| 40.64759827 | 212 | 0.1% | |
| Other values (11240) | 177733 | 98.5% |
| Value | Count | Frequency (%) | |
| -33.93755341 | 9 | < 0.1% | |
| 17.98249054 | 38 | < 0.1% | |
| 18.00682068 | 22 | < 0.1% | |
| 18.01836205 | 20 | < 0.1% | |
| 18.02520371 | 17 | < 0.1% |
| Value | Count | Frequency (%) | |
| 48.78193283 | 6 | < 0.1% | |
| 48.77095795 | 41 | < 0.1% | |
| 47.92603684 | 7 | < 0.1% | |
| 47.91250229 | 4 | < 0.1% | |
| 47.90813828 | 20 | < 0.1% |
| Distinct count | 4487 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -84.91567469 |
|---|---|
| Minimum | -158.0259857 |
| Maximum | 115.2630768 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -158.0259857 |
|---|---|
| 5-th percentile | -121.435112 |
| Q1 | -98.44631195 |
| median | -76.84790802 |
| Q3 | -66.37058258 |
| 95-th percentile | -66.18312836 |
| Maximum | 115.2630768 |
| Range | 273.2890625 |
| Interquartile range (IQR) | 32.07572937 |
Descriptive statistics
| Standard deviation | 21.4332412 |
|---|---|
| Coefficient of variation (CV) | -0.2524061815 |
| Kurtosis | 2.180982226 |
| Mean | -84.91567469 |
| Median Absolute Deviation (MAD) | 17.88808103 |
| Skewness | -0.4984610726 |
| Sum | -15328892.68 |
| Variance | 459.3838283 |
| Value | Count | Frequency (%) | |
| -66.3706131 | 3821 | 2.1% | |
| -66.37057495 | 3523 | 2.0% | |
| -66.37059021 | 3522 | 2.0% | |
| -66.37050629 | 3465 | 1.9% | |
| -66.37055206 | 3417 | 1.9% | |
| -66.37052918 | 3408 | 1.9% | |
| -66.3705368 | 3377 | 1.9% | |
| -66.37055969 | 3242 | 1.8% | |
| -66.37060547 | 3230 | 1.8% | |
| -66.37058258 | 3155 | 1.7% | |
| Other values (4477) | 146359 | 81.1% |
| Value | Count | Frequency (%) | |
| -158.0259857 | 73 | < 0.1% | |
| -158.016037 | 134 | 0.1% | |
| -158.0102234 | 18 | < 0.1% | |
| -158.0047607 | 7 | < 0.1% | |
| -158.0046844 | 43 | < 0.1% |
| Value | Count | Frequency (%) | |
| 115.2630768 | 17 | < 0.1% | |
| 115.0497894 | 17 | < 0.1% | |
| 84.74267578 | 8 | < 0.1% | |
| 82.46199799 | 22 | < 0.1% | |
| 77.09209442 | 32 | < 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| LATAM | |
|---|---|
| Europe | |
| Pacific Asia | |
| USCA | |
| Africa |
| Value | Count | Frequency (%) | |
| LATAM | 51594 | 28.6% | |
| Europe | 50252 | 27.8% | |
| Pacific Asia | 41260 | 22.9% | |
| USCA | 25799 | 14.3% | |
| Africa | 11614 | 6.4% |
Length
| Max length | 12 |
|---|---|
| Mean length | 6.799738532 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 10 | 50.0% | |
| Uppercase_Letter | 9 | 45.0% | |
| Space_Separator | 1 | 5.0% |
| Value | Count | Frequency (%) | |
| Latin | 19 | 95.0% | |
| Common | 1 | 5.0% |
| Value | Count | Frequency (%) | |
| ASCII | 20 | 100.0% |
| Distinct count | 3597 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Santo Domingo | 2211 |
|---|---|
| New York City | 2202 |
| Los Angeles | 1845 |
| Tegucigalpa | 1783 |
| Managua | 1682 |
| Other values (3592) |
| Value | Count | Frequency (%) | |
| Santo Domingo | 2211 | 1.2% | |
| New York City | 2202 | 1.2% | |
| Los Angeles | 1845 | 1.0% | |
| Tegucigalpa | 1783 | 1.0% | |
| Managua | 1682 | 0.9% | |
| Mexico City | 1484 | 0.8% | |
| Manila | 1381 | 0.8% | |
| Philadelphia | 1302 | 0.7% | |
| San Francisco | 1297 | 0.7% | |
| London | 1187 | 0.7% | |
| Other values (3587) | 164145 | 90.9% |
Length
| Max length | 35 |
|---|---|
| Mean length | 8.55421313 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 42 | 53.2% | |
| Uppercase_Letter | 29 | 36.7% | |
| Other_Punctuation | 3 | 3.8% | |
| Dash_Punctuation | 1 | 1.3% | |
| Space_Separator | 1 | 1.3% | |
| Close_Punctuation | 1 | 1.3% | |
| Open_Punctuation | 1 | 1.3% | |
| Control | 1 | 1.3% |
| Value | Count | Frequency (%) | |
| Latin | 71 | 89.9% | |
| Common | 8 | 10.1% |
| Value | Count | Frequency (%) | |
| ASCII | 59 | 100.0% |
| Distinct count | 164 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Estados Unidos | |
|---|---|
| Francia | 13222 |
| México | 13172 |
| Alemania | 9564 |
| Australia | 8497 |
| Other values (159) |
| Value | Count | Frequency (%) | |
| Estados Unidos | 24840 | 13.8% | |
| Francia | 13222 | 7.3% | |
| México | 13172 | 7.3% | |
| Alemania | 9564 | 5.3% | |
| Australia | 8497 | 4.7% | |
| Brasil | 7987 | 4.4% | |
| Reino Unido | 7302 | 4.0% | |
| China | 5758 | 3.2% | |
| Italia | 4989 | 2.8% | |
| India | 4783 | 2.6% | |
| Other values (154) | 80405 | 44.5% |
Length
| Max length | 31 |
|---|---|
| Mean length | 8.772827237 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 32 | 52.5% | |
| Uppercase_Letter | 25 | 41.0% | |
| Dash_Punctuation | 1 | 1.6% | |
| Close_Punctuation | 1 | 1.6% | |
| Space_Separator | 1 | 1.6% | |
| Open_Punctuation | 1 | 1.6% |
| Value | Count | Frequency (%) | |
| Latin | 57 | 93.4% | |
| Common | 4 | 6.6% |
| Value | Count | Frequency (%) | |
| ASCII | 54 | 100.0% |
| Distinct count | 20652 |
|---|---|
| Unique (%) | 11.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6691.379495 |
|---|---|
| Minimum | 1 |
| Maximum | 20757 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 649 |
| Q1 | 3258.5 |
| median | 6457 |
| Q3 | 9779 |
| 95-th percentile | 12383 |
| Maximum | 20757 |
| Range | 20756 |
| Interquartile range (IQR) | 6520.5 |
Descriptive statistics
| Standard deviation | 4162.918106 |
|---|---|
| Coefficient of variation (CV) | 0.6221315215 |
| Kurtosis | 0.01489882226 |
| Mean | 6691.379495 |
| Median Absolute Deviation (MAD) | 3447.119576 |
| Skewness | 0.4887682515 |
| Sum | 1207921135 |
| Variance | 17329887.16 |
| Value | Count | Frequency (%) | |
| 5654 | 47 | < 0.1% | |
| 5004 | 45 | < 0.1% | |
| 10591 | 45 | < 0.1% | |
| 5715 | 44 | < 0.1% | |
| 3708 | 44 | < 0.1% | |
| 9371 | 44 | < 0.1% | |
| 1443 | 43 | < 0.1% | |
| 2641 | 43 | < 0.1% | |
| 791 | 43 | < 0.1% | |
| 12284 | 43 | < 0.1% | |
| Other values (20642) | 180078 | 99.8% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 10 | < 0.1% | |
| 3 | 18 | < 0.1% | |
| 4 | 14 | < 0.1% | |
| 5 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 20757 | 1 | < 0.1% | |
| 20756 | 1 | < 0.1% | |
| 20755 | 1 | < 0.1% | |
| 20754 | 1 | < 0.1% | |
| 20753 | 1 | < 0.1% |
| Distinct count | 65752 |
|---|---|
| Unique (%) | 36.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 11/1/2016 19:01 | 5 |
|---|---|
| 8/5/2015 6:42 | 5 |
| 9/29/2016 16:06 | 5 |
| 9/28/2017 7:53 | 5 |
| 11/18/2016 7:37 | 5 |
| Other values (65747) |
| Value | Count | Frequency (%) | |
| 11/1/2016 19:01 | 5 | < 0.1% | |
| 8/5/2015 6:42 | 5 | < 0.1% | |
| 9/29/2016 16:06 | 5 | < 0.1% | |
| 9/28/2017 7:53 | 5 | < 0.1% | |
| 11/18/2016 7:37 | 5 | < 0.1% | |
| 11/19/2015 3:45 | 5 | < 0.1% | |
| 9/7/2015 9:59 | 5 | < 0.1% | |
| 4/3/2016 14:25 | 5 | < 0.1% | |
| 2/18/2015 8:20 | 5 | < 0.1% | |
| 7/17/2015 12:30 | 5 | < 0.1% | |
| Other values (65742) | 180469 | > 99.9% |
Length
| Max length | 16 |
|---|---|
| Mean length | 14.49898903 |
| Min length | 13 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 76.9% | |
| Other_Punctuation | 2 | 15.4% | |
| Space_Separator | 1 | 7.7% |
| Value | Count | Frequency (%) | |
| Common | 13 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 13 | 100.0% |
| Distinct count | 65752 |
|---|---|
| Unique (%) | 36.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36221.8949 |
|---|---|
| Minimum | 1 |
| Maximum | 77204 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3626.8 |
| Q1 | 18057 |
| median | 36140 |
| Q3 | 54144 |
| 95-th percentile | 68596 |
| Maximum | 77204 |
| Range | 77203 |
| Interquartile range (IQR) | 36087 |
Descriptive statistics
| Standard deviation | 21045.37957 |
|---|---|
| Coefficient of variation (CV) | 0.5810126617 |
| Kurtosis | -1.152935673 |
| Mean | 36221.8949 |
| Median Absolute Deviation (MAD) | 18173.33239 |
| Skewness | 0.03270879463 |
| Sum | 6538740246 |
| Variance | 442908001.2 |
| Value | Count | Frequency (%) | |
| 30397 | 5 | < 0.1% | |
| 16203 | 5 | < 0.1% | |
| 42806 | 5 | < 0.1% | |
| 49302 | 5 | < 0.1% | |
| 60278 | 5 | < 0.1% | |
| 62325 | 5 | < 0.1% | |
| 40753 | 5 | < 0.1% | |
| 47257 | 5 | < 0.1% | |
| 67308 | 5 | < 0.1% | |
| 26414 | 5 | < 0.1% | |
| Other values (65742) | 180469 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 3 | < 0.1% | |
| 4 | 4 | < 0.1% | |
| 5 | 5 | < 0.1% | |
| 7 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 77204 | 1 | < 0.1% | |
| 77203 | 1 | < 0.1% | |
| 77202 | 1 | < 0.1% | |
| 77201 | 1 | < 0.1% | |
| 77200 | 1 | < 0.1% |
| Distinct count | 118 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 692.5097635 |
|---|---|
| Minimum | 19 |
| Maximum | 1363 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 191 |
| Q1 | 403 |
| median | 627 |
| Q3 | 1004 |
| 95-th percentile | 1073 |
| Maximum | 1363 |
| Range | 1344 |
| Interquartile range (IQR) | 601 |
Descriptive statistics
| Standard deviation | 336.4468073 |
|---|---|
| Coefficient of variation (CV) | 0.4858369153 |
| Kurtosis | -1.267493907 |
| Mean | 692.5097635 |
| Median Absolute Deviation (MAD) | 309.2081086 |
| Skewness | 0.1382546099 |
| Sum | 125011170 |
| Variance | 113196.4542 |
| Value | Count | Frequency (%) | |
| 365 | 24515 | 13.6% | |
| 403 | 22246 | 12.3% | |
| 502 | 21035 | 11.7% | |
| 1014 | 19298 | 10.7% | |
| 1004 | 17325 | 9.6% | |
| 1073 | 15500 | 8.6% | |
| 957 | 13729 | 7.6% | |
| 191 | 12169 | 6.7% | |
| 627 | 10617 | 5.9% | |
| 1362 | 838 | 0.5% | |
| Other values (108) | 23247 | 12.9% |
| Value | Count | Frequency (%) | |
| 19 | 64 | < 0.1% | |
| 24 | 74 | < 0.1% | |
| 35 | 65 | < 0.1% | |
| 37 | 262 | 0.1% | |
| 44 | 305 | 0.2% |
| Value | Count | Frequency (%) | |
| 1363 | 650 | 0.4% | |
| 1362 | 838 | 0.5% | |
| 1361 | 529 | 0.3% | |
| 1360 | 357 | 0.2% | |
| 1359 | 492 | 0.3% |
| Distinct count | 1017 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.66474112 |
|---|---|
| Minimum | 0 |
| Maximum | 500 |
| Zeros | 10028 |
| Zeros (%) | 5.6% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5.400000095 |
| median | 14 |
| Q3 | 29.98999977 |
| 95-th percentile | 62.5 |
| Maximum | 500 |
| Range | 500 |
| Interquartile range (IQR) | 24.58999968 |
Descriptive statistics
| Standard deviation | 21.80090095 |
|---|---|
| Coefficient of variation (CV) | 1.054980598 |
| Kurtosis | 25.23126719 |
| Mean | 20.66474112 |
| Median Absolute Deviation (MAD) | 15.68134227 |
| Skewness | 3.039795514 |
| Sum | 3730378.403 |
| Variance | 475.2792824 |
| Value | Count | Frequency (%) | |
| 0 | 10028 | 5.6% | |
| 6 | 4589 | 2.5% | |
| 12 | 4067 | 2.3% | |
| 4 | 3647 | 2.0% | |
| 8 | 3626 | 2.0% | |
| 10 | 3424 | 1.9% | |
| 36 | 3268 | 1.8% | |
| 30 | 3230 | 1.8% | |
| 20 | 3123 | 1.7% | |
| 9 | 2964 | 1.6% | |
| Other values (1007) | 138553 | 76.8% |
| Value | Count | Frequency (%) | |
| 0 | 10028 | 5.6% | |
| 0.100000001 | 3 | < 0.1% | |
| 0.109999999 | 15 | < 0.1% | |
| 0.119999997 | 29 | < 0.1% | |
| 0.150000006 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 500 | 1 | < 0.1% | |
| 400 | 1 | < 0.1% | |
| 375 | 25 | < 0.1% | |
| 360 | 1 | < 0.1% | |
| 340 | 1 | < 0.1% |
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1016681906 |
|---|---|
| Minimum | 0 |
| Maximum | 0.25 |
| Zeros | 10028 |
| Zeros (%) | 5.6% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.039999999 |
| median | 0.100000001 |
| Q3 | 0.159999996 |
| 95-th percentile | 0.25 |
| Maximum | 0.25 |
| Range | 0.25 |
| Interquartile range (IQR) | 0.119999997 |
Descriptive statistics
| Standard deviation | 0.07041521533 |
|---|---|
| Coefficient of variation (CV) | 0.692598294 |
| Kurtosis | -0.9011568627 |
| Mean | 0.1016681906 |
| Median Absolute Deviation (MAD) | 0.06074039626 |
| Skewness | 0.3409276012 |
| Sum | 18353.04009 |
| Variance | 0.004958302549 |
| Value | Count | Frequency (%) | |
| 0.159999996 | 10029 | 5.6% | |
| 0.07 | 10029 | 5.6% | |
| 0.180000007 | 10029 | 5.6% | |
| 0.050000001 | 10029 | 5.6% | |
| 0.039999999 | 10029 | 5.6% | |
| 0.150000006 | 10029 | 5.6% | |
| 0.100000001 | 10029 | 5.6% | |
| 0.129999995 | 10029 | 5.6% | |
| 0.25 | 10029 | 5.6% | |
| 0.090000004 | 10029 | 5.6% | |
| Other values (8) | 80229 | 44.4% |
| Value | Count | Frequency (%) | |
| 0 | 10028 | 5.6% | |
| 0.01 | 10028 | 5.6% | |
| 0.02 | 10028 | 5.6% | |
| 0.029999999 | 10029 | 5.6% | |
| 0.039999999 | 10029 | 5.6% |
| Value | Count | Frequency (%) | |
| 0.25 | 10029 | 5.6% | |
| 0.200000003 | 10029 | 5.6% | |
| 0.180000007 | 10029 | 5.6% | |
| 0.170000002 | 10029 | 5.6% | |
| 0.159999996 | 10029 | 5.6% |
| Distinct count | 180519 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90260 |
|---|---|
| Minimum | 1 |
| Maximum | 180519 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9026.9 |
| Q1 | 45130.5 |
| median | 90260 |
| Q3 | 135389.5 |
| 95-th percentile | 171493.1 |
| Maximum | 180519 |
| Range | 180518 |
| Interquartile range (IQR) | 90259 |
Descriptive statistics
| Standard deviation | 52111.49096 |
|---|---|
| Coefficient of variation (CV) | 0.5773486701 |
| Kurtosis | -1.2 |
| Mean | 90260 |
| Median Absolute Deviation (MAD) | 45129.75 |
| Skewness | 8.455466102e-18 |
| Sum | 1.629364494e+10 |
| Variance | 2715607490 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 79372 | 1 | < 0.1% | |
| 144748 | 1 | < 0.1% | |
| 134507 | 1 | < 0.1% | |
| 132458 | 1 | < 0.1% | |
| 138601 | 1 | < 0.1% | |
| 136552 | 1 | < 0.1% | |
| 159079 | 1 | < 0.1% | |
| 157030 | 1 | < 0.1% | |
| 163173 | 1 | < 0.1% | |
| Other values (180509) | 180509 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 180519 | 1 | < 0.1% | |
| 180518 | 1 | < 0.1% | |
| 180517 | 1 | < 0.1% | |
| 180516 | 1 | < 0.1% | |
| 180515 | 1 | < 0.1% |
| Distinct count | 75 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 141.2325499 |
|---|---|
| Minimum | 9.989999771 |
| Maximum | 1999.98999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 9.989999771 |
|---|---|
| 5-th percentile | 31.98999977 |
| Q1 | 50 |
| median | 59.99000168 |
| Q3 | 199.9900055 |
| 95-th percentile | 399.980011 |
| Maximum | 1999.98999 |
| Range | 1989.99999 |
| Interquartile range (IQR) | 149.9900055 |
Descriptive statistics
| Standard deviation | 139.732492 |
|---|---|
| Coefficient of variation (CV) | 0.9893788087 |
| Kurtosis | 23.31299748 |
| Mean | 141.2325499 |
| Median Absolute Deviation (MAD) | 102.813998 |
| Skewness | 3.19101957 |
| Sum | 25495158.68 |
| Variance | 19525.16932 |
| Value | Count | Frequency (%) | |
| 59.99000168 | 24820 | 13.7% | |
| 129.9900055 | 22372 | 12.4% | |
| 50 | 21035 | 11.7% | |
| 49.97999954 | 19298 | 10.7% | |
| 399.980011 | 17325 | 9.6% | |
| 199.9900055 | 15622 | 8.7% | |
| 299.980011 | 13729 | 7.6% | |
| 99.98999786 | 12433 | 6.9% | |
| 39.99000168 | 11201 | 6.2% | |
| 24.98999977 | 2339 | 1.3% | |
| Other values (65) | 20345 | 11.3% |
| Value | Count | Frequency (%) | |
| 9.989999771 | 285 | 0.2% | |
| 11.28999996 | 271 | 0.2% | |
| 11.53999996 | 529 | 0.3% | |
| 14.98999977 | 593 | 0.3% | |
| 15.98999977 | 602 | 0.3% |
| Value | Count | Frequency (%) | |
| 1999.98999 | 15 | < 0.1% | |
| 1500 | 442 | 0.2% | |
| 999.9899902 | 10 | < 0.1% | |
| 599.9899902 | 21 | < 0.1% | |
| 532.5800171 | 484 | 0.3% |
Order Item Profit Ratio
Real number (ℝ)
| Distinct count | 162 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1206466355 |
|---|---|
| Minimum | -2.75 |
| Maximum | 0.5 |
| Zeros | 1177 |
| Zeros (%) | 0.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -2.75 |
|---|---|
| 5-th percentile | -0.769999981 |
| Q1 | 0.079999998 |
| median | 0.270000011 |
| Q3 | 0.360000014 |
| 95-th percentile | 0.479999989 |
| Maximum | 0.5 |
| Range | 3.25 |
| Interquartile range (IQR) | 0.280000016 |
Descriptive statistics
| Standard deviation | 0.4667956046 |
|---|---|
| Coefficient of variation (CV) | 3.869114151 |
| Kurtosis | 10.15722452 |
| Mean | 0.1206466355 |
| Median Absolute Deviation (MAD) | 0.2941215544 |
| Skewness | -2.893531341 |
| Sum | 21779.00999 |
| Variance | 0.2178981365 |
| Value | Count | Frequency (%) | |
| 0.479999989 | 9197 | 5.1% | |
| 0.349999994 | 7997 | 4.4% | |
| 0.25999999 | 6577 | 3.6% | |
| 0.340000004 | 6507 | 3.6% | |
| 0.469999999 | 6378 | 3.5% | |
| 0.360000014 | 6108 | 3.4% | |
| 0.330000013 | 5789 | 3.2% | |
| 0.49000001 | 5688 | 3.2% | |
| 0.289999992 | 5478 | 3.0% | |
| 0.280000001 | 5403 | 3.0% | |
| Other values (152) | 115397 | 63.9% |
| Value | Count | Frequency (%) | |
| -2.75 | 72 | < 0.1% | |
| -2.700000048 | 252 | 0.1% | |
| -2.650000095 | 90 | < 0.1% | |
| -2.599999905 | 181 | 0.1% | |
| -2.549999952 | 234 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.5 | 2529 | 1.4% | |
| 0.49000001 | 5688 | 3.2% | |
| 0.479999989 | 9197 | 5.1% | |
| 0.469999999 | 6378 | 3.5% | |
| 0.460000008 | 4822 | 2.7% |
Order Item Quantity
Real number (ℝ≥0)
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.127637534 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.453451481 |
|---|---|
| Coefficient of variation (CV) | 0.6831292728 |
| Kurtosis | -0.7537015772 |
| Mean | 2.127637534 |
| Median Absolute Deviation (MAD) | 1.267236976 |
| Skewness | 0.8802518479 |
| Sum | 384079 |
| Variance | 2.112521209 |
| Value | Count | Frequency (%) | |
| 1 | 99134 | 54.9% | |
| 5 | 20385 | 11.3% | |
| 3 | 20350 | 11.3% | |
| 4 | 20335 | 11.3% | |
| 2 | 20315 | 11.3% |
| Value | Count | Frequency (%) | |
| 1 | 99134 | 54.9% | |
| 2 | 20315 | 11.3% | |
| 3 | 20350 | 11.3% | |
| 4 | 20335 | 11.3% | |
| 5 | 20385 | 11.3% |
| Value | Count | Frequency (%) | |
| 5 | 20385 | 11.3% | |
| 4 | 20335 | 11.3% | |
| 3 | 20350 | 11.3% | |
| 2 | 20315 | 11.3% | |
| 1 | 99134 | 54.9% |
| Distinct count | 193 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203.7720961 |
|---|---|
| Minimum | 9.989999771 |
| Maximum | 1999.98999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 9.989999771 |
|---|---|
| 5-th percentile | 49.97999954 |
| Q1 | 119.9800034 |
| median | 199.9199982 |
| Q3 | 299.9500122 |
| 95-th percentile | 399.980011 |
| Maximum | 1999.98999 |
| Range | 1989.99999 |
| Interquartile range (IQR) | 179.9700088 |
Descriptive statistics
| Standard deviation | 132.2730775 |
|---|---|
| Coefficient of variation (CV) | 0.649122623 |
| Kurtosis | 23.93656127 |
| Mean | 203.7720961 |
| Median Absolute Deviation (MAD) | 95.94152385 |
| Skewness | 2.884249049 |
| Sum | 36784735.01 |
| Variance | 17496.16703 |
| Value | Count | Frequency (%) | |
| 129.9900055 | 22372 | 12.4% | |
| 399.980011 | 17325 | 9.6% | |
| 199.9900055 | 15622 | 8.7% | |
| 299.980011 | 13729 | 7.6% | |
| 179.9700012 | 5016 | 2.8% | |
| 299.9500122 | 4988 | 2.8% | |
| 119.9800034 | 4968 | 2.8% | |
| 239.9600067 | 4955 | 2.7% | |
| 59.99000168 | 4893 | 2.7% | |
| 50 | 4432 | 2.5% | |
| Other values (183) | 82219 | 45.5% |
| Value | Count | Frequency (%) | |
| 9.989999771 | 56 | < 0.1% | |
| 11.28999996 | 271 | 0.2% | |
| 11.53999996 | 529 | 0.3% | |
| 14.98999977 | 124 | 0.1% | |
| 15.98999977 | 118 | 0.1% |
| Value | Count | Frequency (%) | |
| 1999.98999 | 15 | < 0.1% | |
| 1500 | 442 | 0.2% | |
| 999.9899902 | 10 | < 0.1% | |
| 599.9899902 | 21 | < 0.1% | |
| 532.5800171 | 484 | 0.3% |
| Distinct count | 2927 |
|---|---|
| Unique (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 183.1076085 |
|---|---|
| Minimum | 7.489999771 |
| Maximum | 1939.98999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 7.489999771 |
|---|---|
| 5-th percentile | 41.5 |
| Q1 | 104.3799973 |
| median | 163.9900055 |
| Q3 | 247.3999939 |
| 95-th percentile | 383.980011 |
| Maximum | 1939.98999 |
| Range | 1932.49999 |
| Interquartile range (IQR) | 143.0199966 |
Descriptive statistics
| Standard deviation | 120.04367 |
|---|---|
| Coefficient of variation (CV) | 0.6555908354 |
| Kurtosis | 23.92036151 |
| Mean | 183.1076085 |
| Median Absolute Deviation (MAD) | 87.66090517 |
| Skewness | 2.888446057 |
| Sum | 33054402.38 |
| Variance | 14410.48271 |
| Value | Count | Frequency (%) | |
| 122.8399963 | 1264 | 0.7% | |
| 109.1900024 | 1247 | 0.7% | |
| 114.3899994 | 1243 | 0.7% | |
| 113.0899963 | 1243 | 0.7% | |
| 129.9900055 | 1243 | 0.7% | |
| 126.0899963 | 1243 | 0.7% | |
| 107.8899994 | 1243 | 0.7% | |
| 123.4899979 | 1243 | 0.7% | |
| 97.48999786 | 1243 | 0.7% | |
| 110.4899979 | 1243 | 0.7% | |
| Other values (2917) | 168064 | 93.1% |
| Value | Count | Frequency (%) | |
| 7.489999771 | 3 | < 0.1% | |
| 7.989999771 | 3 | < 0.1% | |
| 8.18999958 | 3 | < 0.1% | |
| 8.289999962 | 3 | < 0.1% | |
| 8.390000343 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1939.98999 | 1 | < 0.1% | |
| 1919.98999 | 1 | < 0.1% | |
| 1899.98999 | 1 | < 0.1% | |
| 1889.98999 | 1 | < 0.1% | |
| 1859.98999 | 1 | < 0.1% |
| Distinct count | 21998 |
|---|---|
| Unique (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.97498864 |
|---|---|
| Minimum | -4274.97998 |
| Maximum | 911.7999878 |
| Zeros | 1177 |
| Zeros (%) | 0.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -4274.97998 |
|---|---|
| 5-th percentile | -139.2509994 |
| Q1 | 7 |
| median | 31.52000046 |
| Q3 | 64.80000305 |
| 95-th percentile | 132.2899933 |
| Maximum | 911.7999878 |
| Range | 5186.779968 |
| Interquartile range (IQR) | 57.80000305 |
Descriptive statistics
| Standard deviation | 104.4335257 |
|---|---|
| Coefficient of variation (CV) | 4.752381331 |
| Kurtosis | 71.37725866 |
| Mean | 21.97498864 |
| Median Absolute Deviation (MAD) | 56.08869441 |
| Skewness | -4.74183407 |
| Sum | 3966902.974 |
| Variance | 10906.3613 |
| Value | Count | Frequency (%) | |
| 0 | 1177 | 0.7% | |
| 143.9900055 | 199 | 0.1% | |
| 72 | 194 | 0.1% | |
| 46.79999924 | 188 | 0.1% | |
| 24 | 181 | 0.1% | |
| 18 | 175 | 0.1% | |
| 63.70000076 | 172 | 0.1% | |
| 62.40000153 | 168 | 0.1% | |
| 14.39999962 | 166 | 0.1% | |
| 12 | 166 | 0.1% | |
| Other values (21988) | 177733 | 98.5% |
| Value | Count | Frequency (%) | |
| -4274.97998 | 1 | < 0.1% | |
| -3442.5 | 1 | < 0.1% | |
| -3366 | 1 | < 0.1% | |
| -3000 | 1 | < 0.1% | |
| -2592 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 911.7999878 | 1 | < 0.1% | |
| 864 | 1 | < 0.1% | |
| 721.5999756 | 1 | < 0.1% | |
| 720.2999878 | 1 | < 0.1% | |
| 720 | 2 | < 0.1% |
| Distinct count | 23 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Central America | |
|---|---|
| Western Europe | |
| South America | 14935 |
| Oceania | 10148 |
| Northern Europe | 9792 |
| Other values (18) |
| Value | Count | Frequency (%) | |
| Central America | 28341 | 15.7% | |
| Western Europe | 27109 | 15.0% | |
| South America | 14935 | 8.3% | |
| Oceania | 10148 | 5.6% | |
| Northern Europe | 9792 | 5.4% | |
| Southeast Asia | 9539 | 5.3% | |
| Southern Europe | 9431 | 5.2% | |
| Caribbean | 8318 | 4.6% | |
| West of USA | 7993 | 4.4% | |
| South Asia | 7731 | 4.3% | |
| Other values (13) | 47182 | 26.1% |
Length
| Max length | 15 |
|---|---|
| Mean length | 12.63430442 |
| Min length | 6 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 17 | 65.4% | |
| Uppercase_Letter | 8 | 30.8% | |
| Space_Separator | 1 | 3.8% |
| Value | Count | Frequency (%) | |
| Latin | 25 | 96.2% | |
| Common | 1 | 3.8% |
| Value | Count | Frequency (%) | |
| ASCII | 26 | 100.0% |
| Distinct count | 1089 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Inglaterra | 6722 |
|---|---|
| California | 4966 |
| Isla de Francia | 4580 |
| Renania del Norte-Westfalia | 3303 |
| San Salvador | 3055 |
| Other values (1084) |
| Value | Count | Frequency (%) | |
| Inglaterra | 6722 | 3.7% | |
| California | 4966 | 2.8% | |
| Isla de Francia | 4580 | 2.5% | |
| Renania del Norte-Westfalia | 3303 | 1.8% | |
| San Salvador | 3055 | 1.7% | |
| Nueva York | 2753 | 1.5% | |
| Distrito Federal | 2559 | 1.4% | |
| Texas | 2446 | 1.4% | |
| Nueva Gales del Sur | 2370 | 1.3% | |
| Santo Domingo | 2211 | 1.2% | |
| Other values (1079) | 145554 | 80.6% |
Length
| Max length | 36 |
|---|---|
| Mean length | 10.87261729 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 45 | 54.2% | |
| Uppercase_Letter | 30 | 36.1% | |
| Control | 2 | 2.4% | |
| Other_Punctuation | 2 | 2.4% | |
| Dash_Punctuation | 1 | 1.2% | |
| Space_Separator | 1 | 1.2% | |
| Close_Punctuation | 1 | 1.2% | |
| Open_Punctuation | 1 | 1.2% |
| Value | Count | Frequency (%) | |
| Latin | 75 | 90.4% | |
| Common | 8 | 9.6% |
| Value | Count | Frequency (%) | |
| ASCII | 58 | 100.0% |
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| COMPLETE | |
|---|---|
| PENDING_PAYMENT | |
| PROCESSING | |
| PENDING | |
| CLOSED | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| COMPLETE | 59491 | 33.0% | |
| PENDING_PAYMENT | 39832 | 22.1% | |
| PROCESSING | 21902 | 12.1% | |
| PENDING | 20227 | 11.2% | |
| CLOSED | 19616 | 10.9% | |
| ON_HOLD | 9804 | 5.4% | |
| SUSPECTED_FRAUD | 4062 | 2.3% | |
| CANCELED | 3692 | 2.0% | |
| PAYMENT_REVIEW | 1893 | 1.0% |
Length
| Max length | 15 |
|---|---|
| Mean length | 9.62396756 |
| Min length | 6 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 20 | 95.2% | |
| Connector_Punctuation | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| Latin | 20 | 95.2% | |
| Common | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| ASCII | 21 | 100.0% |
| Distinct count | 609 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 155679 |
| Missing (%) | 86.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55426.13233 |
|---|---|
| Minimum | 1040 |
| Maximum | 99301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1040 |
|---|---|
| 5-th percentile | 10009 |
| Q1 | 23464 |
| median | 59405 |
| Q3 | 90008 |
| 95-th percentile | 98026 |
| Maximum | 99301 |
| Range | 98261 |
| Interquartile range (IQR) | 66544 |
Descriptive statistics
| Standard deviation | 31919.2791 |
|---|---|
| Coefficient of variation (CV) | 0.5758886244 |
| Kurtosis | -1.48173452 |
| Mean | 55426.13233 |
| Median Absolute Deviation (MAD) | 28934.40503 |
| Skewness | -0.1403113969 |
| Sum | 1376785127 |
| Variance | 1018840378 |
| Value | Count | Frequency (%) | |
| 10035 | 648 | 0.4% | |
| 10009 | 550 | 0.3% | |
| 10024 | 541 | 0.3% | |
| 94122 | 526 | 0.3% | |
| 10011 | 463 | 0.3% | |
| 94110 | 407 | 0.2% | |
| 98105 | 406 | 0.2% | |
| 19140 | 386 | 0.2% | |
| 90049 | 368 | 0.2% | |
| 98103 | 366 | 0.2% | |
| Other values (599) | 20179 | 11.2% | |
| (Missing) | 155679 | 86.2% |
| Value | Count | Frequency (%) | |
| 1040 | 3 | < 0.1% | |
| 1453 | 17 | < 0.1% | |
| 1752 | 6 | < 0.1% | |
| 1810 | 13 | < 0.1% | |
| 1841 | 88 | < 0.1% |
| Value | Count | Frequency (%) | |
| 99301 | 10 | < 0.1% | |
| 99207 | 22 | < 0.1% | |
| 98661 | 12 | < 0.1% | |
| 98632 | 10 | < 0.1% | |
| 98502 | 9 | < 0.1% |
| Distinct count | 118 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 692.5097635 |
|---|---|
| Minimum | 19 |
| Maximum | 1363 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 191 |
| Q1 | 403 |
| median | 627 |
| Q3 | 1004 |
| 95-th percentile | 1073 |
| Maximum | 1363 |
| Range | 1344 |
| Interquartile range (IQR) | 601 |
Descriptive statistics
| Standard deviation | 336.4468073 |
|---|---|
| Coefficient of variation (CV) | 0.4858369153 |
| Kurtosis | -1.267493907 |
| Mean | 692.5097635 |
| Median Absolute Deviation (MAD) | 309.2081086 |
| Skewness | 0.1382546099 |
| Sum | 125011170 |
| Variance | 113196.4542 |
| Value | Count | Frequency (%) | |
| 365 | 24515 | 13.6% | |
| 403 | 22246 | 12.3% | |
| 502 | 21035 | 11.7% | |
| 1014 | 19298 | 10.7% | |
| 1004 | 17325 | 9.6% | |
| 1073 | 15500 | 8.6% | |
| 957 | 13729 | 7.6% | |
| 191 | 12169 | 6.7% | |
| 627 | 10617 | 5.9% | |
| 1362 | 838 | 0.5% | |
| Other values (108) | 23247 | 12.9% |
| Value | Count | Frequency (%) | |
| 19 | 64 | < 0.1% | |
| 24 | 74 | < 0.1% | |
| 35 | 65 | < 0.1% | |
| 37 | 262 | 0.1% | |
| 44 | 305 | 0.2% |
| Value | Count | Frequency (%) | |
| 1363 | 650 | 0.4% | |
| 1362 | 838 | 0.5% | |
| 1361 | 529 | 0.3% | |
| 1360 | 357 | 0.2% | |
| 1359 | 492 | 0.3% |
| Distinct count | 51 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.85145054 |
|---|---|
| Minimum | 2 |
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 18 |
| median | 29 |
| Q3 | 45 |
| 95-th percentile | 48 |
| Maximum | 76 |
| Range | 74 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 15.64006388 |
|---|---|
| Coefficient of variation (CV) | 0.4910314481 |
| Kurtosis | -0.6032610083 |
| Mean | 31.85145054 |
| Median Absolute Deviation (MAD) | 13.94913209 |
| Skewness | 0.3616247994 |
| Sum | 5749792 |
| Variance | 244.6115983 |
| Value | Count | Frequency (%) | |
| 17 | 24551 | 13.6% | |
| 18 | 22246 | 12.3% | |
| 24 | 21035 | 11.7% | |
| 46 | 19298 | 10.7% | |
| 45 | 17325 | 9.6% | |
| 48 | 15540 | 8.6% | |
| 43 | 13729 | 7.6% | |
| 9 | 12487 | 6.9% | |
| 29 | 10984 | 6.1% | |
| 37 | 2029 | 1.1% | |
| Other values (41) | 21295 | 11.8% |
| Value | Count | Frequency (%) | |
| 2 | 138 | 0.1% | |
| 3 | 632 | 0.4% | |
| 4 | 67 | < 0.1% | |
| 5 | 343 | 0.2% | |
| 6 | 328 | 0.2% |
| Value | Count | Frequency (%) | |
| 76 | 650 | 0.4% | |
| 75 | 838 | 0.5% | |
| 74 | 529 | 0.3% | |
| 73 | 357 | 0.2% | |
| 72 | 492 | 0.3% |
| Distinct count | 118 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| http://images.acmesports.sports/Perfect+Fitness+Perfect+Rip+Deck | |
|---|---|
| http://images.acmesports.sports/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat | |
| http://images.acmesports.sports/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo | |
| http://images.acmesports.sports/O%27Brien+Men%27s+Neoprene+Life+Vest | |
| http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | |
| Other values (113) |
| Value | Count | Frequency (%) | |
| http://images.acmesports.sports/Perfect+Fitness+Perfect+Rip+Deck | 24515 | 13.6% | |
| http://images.acmesports.sports/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat | 22246 | 12.3% | |
| http://images.acmesports.sports/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo | 21035 | 11.7% | |
| http://images.acmesports.sports/O%27Brien+Men%27s+Neoprene+Life+Vest | 19298 | 10.7% | |
| http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | 17325 | 9.6% | |
| http://images.acmesports.sports/Pelican+Sunstream+100+Kayak | 15500 | 8.6% | |
| http://images.acmesports.sports/Diamondback+Women%27s+Serene+Classic+Comfort+Bike+2014 | 13729 | 7.6% | |
| http://images.acmesports.sports/Nike+Men%27s+Free+5.0%2B+Running+Shoe | 12169 | 6.7% | |
| http://images.acmesports.sports/Under+Armour+Girls%27+Toddler+Spine+Surge+Running+Shoe | 10617 | 5.9% | |
| http://images.acmesports.sports/Fighting+video+games | 838 | 0.5% | |
| Other values (108) | 23247 | 12.9% |
| Value | Count | Frequency (%) | |
| http | 180519 | 100.0% |
| Value | Count | Frequency (%) | |
| images.acmesports.sports | 180519 | 100.0% |
| Value | Count | Frequency (%) | |
| /Perfect+Fitness+Perfect+Rip+Deck | 24515 | 13.6% | |
| /Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat | 22246 | 12.3% | |
| /Nike+Men%27s+Dri-FIT+Victory+Golf+Polo | 21035 | 11.7% | |
| /O%27Brien+Men%27s+Neoprene+Life+Vest | 19298 | 10.7% | |
| /Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | 17325 | 9.6% | |
| /Pelican+Sunstream+100+Kayak | 15500 | 8.6% | |
| /Diamondback+Women%27s+Serene+Classic+Comfort+Bike+2014 | 13729 | 7.6% | |
| /Nike+Men%27s+Free+5.0%2B+Running+Shoe | 12169 | 6.7% | |
| /Under+Armour+Girls%27+Toddler+Spine+Surge+Running+Shoe | 10617 | 5.9% | |
| /Fighting+video+games | 838 | 0.5% | |
| Other values (108) | 23247 | 12.9% |
| Value | Count | Frequency (%) | |
| 180519 | 100.0% |
| Value | Count | Frequency (%) | |
| 180519 | 100.0% |
| Distinct count | 118 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Perfect Fitness Perfect Rip Deck | |
|---|---|
| Nike Men's CJ Elite 2 TD Football Cleat | |
| Nike Men's Dri-FIT Victory Golf Polo | |
| O'Brien Men's Neoprene Life Vest | |
| Field & Stream Sportsman 16 Gun Fire Safe | |
| Other values (113) |
| Value | Count | Frequency (%) | |
| Perfect Fitness Perfect Rip Deck | 24515 | 13.6% | |
| Nike Men's CJ Elite 2 TD Football Cleat | 22246 | 12.3% | |
| Nike Men's Dri-FIT Victory Golf Polo | 21035 | 11.7% | |
| O'Brien Men's Neoprene Life Vest | 19298 | 10.7% | |
| Field & Stream Sportsman 16 Gun Fire Safe | 17325 | 9.6% | |
| Pelican Sunstream 100 Kayak | 15500 | 8.6% | |
| Diamondback Women's Serene Classic Comfort Bi | 13729 | 7.6% | |
| Nike Men's Free 5.0+ Running Shoe | 12169 | 6.7% | |
| Under Armour Girls' Toddler Spine Surge Runni | 10617 | 5.9% | |
| Fighting video games | 838 | 0.5% | |
| Other values (108) | 23247 | 12.9% |
Length
| Max length | 45 |
|---|---|
| Mean length | 35.12000399 |
| Min length | 5 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 25 | 37.9% | |
| Lowercase_Letter | 24 | 36.4% | |
| Decimal_Number | 10 | 15.2% | |
| Other_Punctuation | 4 | 6.1% | |
| Math_Symbol | 1 | 1.5% | |
| Space_Separator | 1 | 1.5% | |
| Dash_Punctuation | 1 | 1.5% |
| Value | Count | Frequency (%) | |
| Latin | 49 | 74.2% | |
| Common | 17 | 25.8% |
| Value | Count | Frequency (%) | |
| ASCII | 66 | 100.0% |
| Distinct count | 75 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 141.2325499 |
|---|---|
| Minimum | 9.989999771 |
| Maximum | 1999.98999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 9.989999771 |
|---|---|
| 5-th percentile | 31.98999977 |
| Q1 | 50 |
| median | 59.99000168 |
| Q3 | 199.9900055 |
| 95-th percentile | 399.980011 |
| Maximum | 1999.98999 |
| Range | 1989.99999 |
| Interquartile range (IQR) | 149.9900055 |
Descriptive statistics
| Standard deviation | 139.732492 |
|---|---|
| Coefficient of variation (CV) | 0.9893788087 |
| Kurtosis | 23.31299748 |
| Mean | 141.2325499 |
| Median Absolute Deviation (MAD) | 102.813998 |
| Skewness | 3.19101957 |
| Sum | 25495158.68 |
| Variance | 19525.16932 |
| Value | Count | Frequency (%) | |
| 59.99000168 | 24820 | 13.7% | |
| 129.9900055 | 22372 | 12.4% | |
| 50 | 21035 | 11.7% | |
| 49.97999954 | 19298 | 10.7% | |
| 399.980011 | 17325 | 9.6% | |
| 199.9900055 | 15622 | 8.7% | |
| 299.980011 | 13729 | 7.6% | |
| 99.98999786 | 12433 | 6.9% | |
| 39.99000168 | 11201 | 6.2% | |
| 24.98999977 | 2339 | 1.3% | |
| Other values (65) | 20345 | 11.3% |
| Value | Count | Frequency (%) | |
| 9.989999771 | 285 | 0.2% | |
| 11.28999996 | 271 | 0.2% | |
| 11.53999996 | 529 | 0.3% | |
| 14.98999977 | 593 | 0.3% | |
| 15.98999977 | 602 | 0.3% |
| Value | Count | Frequency (%) | |
| 1999.98999 | 15 | < 0.1% | |
| 1500 | 442 | 0.2% | |
| 999.9899902 | 10 | < 0.1% | |
| 599.9899902 | 21 | < 0.1% | |
| 532.5800171 | 484 | 0.3% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 180519 | 100.0% |
| Distinct count | 63701 |
|---|---|
| Unique (%) | 35.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 5/21/2015 15:34 | 10 |
|---|---|
| 10/30/2016 3:16 | 10 |
| 7/16/2015 10:14 | 10 |
| 10/8/2016 23:37 | 10 |
| 5/21/2015 10:19 | 10 |
| Other values (63696) |
| Value | Count | Frequency (%) | |
| 5/21/2015 15:34 | 10 | < 0.1% | |
| 10/30/2016 3:16 | 10 | < 0.1% | |
| 7/16/2015 10:14 | 10 | < 0.1% | |
| 10/8/2016 23:37 | 10 | < 0.1% | |
| 5/21/2015 10:19 | 10 | < 0.1% | |
| 7/5/2017 10:59 | 10 | < 0.1% | |
| 11/6/2015 23:55 | 10 | < 0.1% | |
| 7/19/2016 5:41 | 10 | < 0.1% | |
| 9/10/2015 20:19 | 10 | < 0.1% | |
| 1/4/2017 17:11 | 10 | < 0.1% | |
| Other values (63691) | 180419 | 99.9% |
Length
| Max length | 16 |
|---|---|
| Mean length | 14.50194162 |
| Min length | 13 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 76.9% | |
| Other_Punctuation | 2 | 15.4% | |
| Space_Separator | 1 | 7.7% |
| Value | Count | Frequency (%) | |
| Common | 13 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 13 | 100.0% |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 9737 |
| Value | Count | Frequency (%) | |
| Standard Class | 107752 | 59.7% | |
| Second Class | 35216 | 19.5% | |
| First Class | 27814 | 15.4% | |
| Same Day | 9737 | 5.4% |
Length
| Max length | 14 |
|---|---|
| Mean length | 12.82396867 |
| Min length | 8 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 13 | 72.2% | |
| Uppercase_Letter | 4 | 22.2% | |
| Space_Separator | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| Latin | 17 | 94.4% | |
| Common | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| ASCII | 18 | 100.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| Type | Days for shipping (real) | Days for shipment (scheduled) | Benefit per order | Sales per customer | Delivery Status | Late_delivery_risk | Category Id | Category Name | Customer City | Customer Country | Customer Email | Customer Fname | Customer Id | Customer Lname | Customer Password | Customer Segment | Customer State | Customer Street | Customer Zipcode | Department Id | Department Name | Latitude | Longitude | Market | Order City | Order Country | Order Customer Id | order date (DateOrders) | Order Id | Order Item Cardprod Id | Order Item Discount | Order Item Discount Rate | Order Item Id | Order Item Product Price | Order Item Profit Ratio | Order Item Quantity | Sales | Order Item Total | Order Profit Per Order | Order Region | Order State | Order Status | Order Zipcode | Product Card Id | Product Category Id | Product Description | Product Image | Product Name | Product Price | Product Status | shipping date (DateOrders) | Shipping Mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | DEBIT | 3 | 4 | 91.250000 | 314.640015 | Advance shipping | 0 | 73 | Sporting Goods | Caguas | Puerto Rico | XXXXXXXXX | Cally | 20755 | Holloway | XXXXXXXXX | Consumer | PR | 5365 Noble Nectar Island | 725.0 | 2 | Fitness | 18.251453 | -66.037056 | Pacific Asia | Bekasi | Indonesia | 20755 | 1/31/2018 22:56 | 77202 | 1360 | 13.110000 | 0.04 | 180517 | 327.75 | 0.29 | 1 | 327.75 | 314.640015 | 91.250000 | Southeast Asia | Java Occidental | COMPLETE | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 2/3/2018 22:56 | Standard Class |
| 1 | TRANSFER | 5 | 4 | -249.089996 | 311.359985 | Late delivery | 1 | 73 | Sporting Goods | Caguas | Puerto Rico | XXXXXXXXX | Irene | 19492 | Luna | XXXXXXXXX | Consumer | PR | 2679 Rustic Loop | 725.0 | 2 | Fitness | 18.279451 | -66.037064 | Pacific Asia | Bikaner | India | 19492 | 1/13/2018 12:27 | 75939 | 1360 | 16.389999 | 0.05 | 179254 | 327.75 | -0.80 | 1 | 327.75 | 311.359985 | -249.089996 | South Asia | Rajastán | PENDING | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/18/2018 12:27 | Standard Class |
| 2 | CASH | 4 | 4 | -247.779999 | 309.720001 | Shipping on time | 0 | 73 | Sporting Goods | San Jose | EE. UU. | XXXXXXXXX | Gillian | 19491 | Maldonado | XXXXXXXXX | Consumer | CA | 8510 Round Bear Gate | 95125.0 | 2 | Fitness | 37.292233 | -121.881279 | Pacific Asia | Bikaner | India | 19491 | 1/13/2018 12:06 | 75938 | 1360 | 18.030001 | 0.06 | 179253 | 327.75 | -0.80 | 1 | 327.75 | 309.720001 | -247.779999 | South Asia | Rajastán | CLOSED | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/17/2018 12:06 | Standard Class |
| 3 | DEBIT | 3 | 4 | 22.860001 | 304.809998 | Advance shipping | 0 | 73 | Sporting Goods | Los Angeles | EE. UU. | XXXXXXXXX | Tana | 19490 | Tate | XXXXXXXXX | Home Office | CA | 3200 Amber Bend | 90027.0 | 2 | Fitness | 34.125946 | -118.291016 | Pacific Asia | Townsville | Australia | 19490 | 1/13/2018 11:45 | 75937 | 1360 | 22.940001 | 0.07 | 179252 | 327.75 | 0.08 | 1 | 327.75 | 304.809998 | 22.860001 | Oceania | Queensland | COMPLETE | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/16/2018 11:45 | Standard Class |
| 4 | PAYMENT | 2 | 4 | 134.210007 | 298.250000 | Advance shipping | 0 | 73 | Sporting Goods | Caguas | Puerto Rico | XXXXXXXXX | Orli | 19489 | Hendricks | XXXXXXXXX | Corporate | PR | 8671 Iron Anchor Corners | 725.0 | 2 | Fitness | 18.253769 | -66.037048 | Pacific Asia | Townsville | Australia | 19489 | 1/13/2018 11:24 | 75936 | 1360 | 29.500000 | 0.09 | 179251 | 327.75 | 0.45 | 1 | 327.75 | 298.250000 | 134.210007 | Oceania | Queensland | PENDING_PAYMENT | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/15/2018 11:24 | Standard Class |
| 5 | TRANSFER | 6 | 4 | 18.580000 | 294.980011 | Shipping canceled | 0 | 73 | Sporting Goods | Tonawanda | EE. UU. | XXXXXXXXX | Kimberly | 19488 | Flowers | XXXXXXXXX | Consumer | NY | 2122 Hazy Corner | 14150.0 | 2 | Fitness | 43.013969 | -78.879066 | Pacific Asia | Toowoomba | Australia | 19488 | 1/13/2018 11:03 | 75935 | 1360 | 32.779999 | 0.10 | 179250 | 327.75 | 0.06 | 1 | 327.75 | 294.980011 | 18.580000 | Oceania | Queensland | CANCELED | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/19/2018 11:03 | Standard Class |
| 6 | DEBIT | 2 | 1 | 95.180000 | 288.420013 | Late delivery | 1 | 73 | Sporting Goods | Caguas | Puerto Rico | XXXXXXXXX | Constance | 19487 | Terrell | XXXXXXXXX | Home Office | PR | 1879 Green Pine Bank | 725.0 | 2 | Fitness | 18.242538 | -66.037056 | Pacific Asia | Guangzhou | China | 19487 | 1/13/2018 10:42 | 75934 | 1360 | 39.330002 | 0.12 | 179249 | 327.75 | 0.33 | 1 | 327.75 | 288.420013 | 95.180000 | Eastern Asia | Guangdong | COMPLETE | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/15/2018 10:42 | First Class |
| 7 | TRANSFER | 2 | 1 | 68.430000 | 285.140015 | Late delivery | 1 | 73 | Sporting Goods | Miami | EE. UU. | XXXXXXXXX | Erica | 19486 | Stevens | XXXXXXXXX | Corporate | FL | 7595 Cotton Log Row | 33162.0 | 2 | Fitness | 25.928869 | -80.162872 | Pacific Asia | Guangzhou | China | 19486 | 1/13/2018 10:21 | 75933 | 1360 | 42.610001 | 0.13 | 179248 | 327.75 | 0.24 | 1 | 327.75 | 285.140015 | 68.430000 | Eastern Asia | Guangdong | PROCESSING | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/15/2018 10:21 | First Class |
| 8 | CASH | 3 | 2 | 133.720001 | 278.589996 | Late delivery | 1 | 73 | Sporting Goods | Caguas | Puerto Rico | XXXXXXXXX | Nichole | 19485 | Olsen | XXXXXXXXX | Corporate | PR | 2051 Dusty Route | 725.0 | 2 | Fitness | 18.233223 | -66.037056 | Pacific Asia | Guangzhou | China | 19485 | 1/13/2018 10:00 | 75932 | 1360 | 49.160000 | 0.15 | 179247 | 327.75 | 0.48 | 1 | 327.75 | 278.589996 | 133.720001 | Eastern Asia | Guangdong | CLOSED | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/16/2018 10:00 | Second Class |
| 9 | CASH | 2 | 1 | 132.149994 | 275.309998 | Late delivery | 1 | 73 | Sporting Goods | San Ramon | EE. UU. | XXXXXXXXX | Oprah | 19484 | Delacruz | XXXXXXXXX | Corporate | CA | 9139 Blue Blossom Court | 94583.0 | 2 | Fitness | 37.773991 | -121.966629 | Pacific Asia | Guangzhou | China | 19484 | 1/13/2018 9:39 | 75931 | 1360 | 52.439999 | 0.16 | 179246 | 327.75 | 0.48 | 1 | 327.75 | 275.309998 | 132.149994 | Eastern Asia | Guangdong | CLOSED | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/15/2018 9:39 | First Class |
Last rows
| Type | Days for shipping (real) | Days for shipment (scheduled) | Benefit per order | Sales per customer | Delivery Status | Late_delivery_risk | Category Id | Category Name | Customer City | Customer Country | Customer Email | Customer Fname | Customer Id | Customer Lname | Customer Password | Customer Segment | Customer State | Customer Street | Customer Zipcode | Department Id | Department Name | Latitude | Longitude | Market | Order City | Order Country | Order Customer Id | order date (DateOrders) | Order Id | Order Item Cardprod Id | Order Item Discount | Order Item Discount Rate | Order Item Id | Order Item Product Price | Order Item Profit Ratio | Order Item Quantity | Sales | Order Item Total | Order Profit Per Order | Order Region | Order State | Order Status | Order Zipcode | Product Card Id | Product Category Id | Product Description | Product Image | Product Name | Product Price | Product Status | shipping date (DateOrders) | Shipping Mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180509 | PAYMENT | 3 | 4 | 0.000000 | 335.980011 | Advance shipping | 0 | 45 | Fishing | Caguas | Puerto Rico | XXXXXXXXX | Melissa | 7 | Wilcox | XXXXXXXXX | Corporate | PR | 9453 High Concession | 725.0 | 7 | Fan Shop | 18.359095 | -66.079956 | Pacific Asia | Guangshui | China | 7 | 1/16/2016 6:49 | 26052 | 1004 | 64.0 | 0.16 | 65202 | 399.980011 | 0.00 | 1 | 399.980011 | 335.980011 | 0.000000 | Eastern Asia | Hubei | PENDING_PAYMENT | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/19/2016 6:49 | Standard Class |
| 180510 | PAYMENT | 3 | 4 | 165.990005 | 331.980011 | Advance shipping | 0 | 45 | Fishing | Caguas | Puerto Rico | XXXXXXXXX | Melissa | 7 | Wilcox | XXXXXXXXX | Corporate | PR | 9453 High Concession | 725.0 | 7 | Fan Shop | 18.359095 | -66.079956 | Pacific Asia | Guangshui | China | 7 | 1/16/2016 6:49 | 26052 | 1004 | 68.0 | 0.17 | 65201 | 399.980011 | 0.50 | 1 | 399.980011 | 331.980011 | 165.990005 | Eastern Asia | Hubei | PENDING_PAYMENT | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/19/2016 6:49 | Standard Class |
| 180511 | DEBIT | 2 | 2 | 157.429993 | 327.980011 | Shipping on time | 0 | 45 | Fishing | Chula Vista | EE. UU. | XXXXXXXXX | Olivia | 9314 | Smith | XXXXXXXXX | Consumer | CA | 3760 Stony Promenade | 91911.0 | 7 | Fan Shop | 32.611141 | -117.073662 | Pacific Asia | Chengdu | China | 9314 | 1/16/2016 6:28 | 26051 | 1004 | 72.0 | 0.18 | 65195 | 399.980011 | 0.48 | 1 | 399.980011 | 327.980011 | 157.429993 | Eastern Asia | Sichuan | ON_HOLD | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/18/2016 6:28 | Second Class |
| 180512 | DEBIT | 6 | 4 | 86.400002 | 319.980011 | Late delivery | 1 | 45 | Fishing | Caguas | Puerto Rico | XXXXXXXXX | Mary | 7396 | Madden | XXXXXXXXX | Home Office | PR | 9918 Lazy Cape | 725.0 | 7 | Fan Shop | 18.245256 | -66.370621 | Pacific Asia | Chengdu | China | 7396 | 1/16/2016 6:07 | 26050 | 1004 | 80.0 | 0.20 | 65194 | 399.980011 | 0.27 | 1 | 399.980011 | 319.980011 | 86.400002 | Eastern Asia | Sichuan | COMPLETE | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/22/2016 6:07 | Standard Class |
| 180513 | PAYMENT | 3 | 4 | 119.989998 | 299.989990 | Advance shipping | 0 | 45 | Fishing | Lancaster | EE. UU. | XXXXXXXXX | Mary | 3080 | Smith | XXXXXXXXX | Home Office | OH | 8600 Red Goose Abbey | 43130.0 | 7 | Fan Shop | 39.715977 | -82.599297 | Pacific Asia | Shanghái | China | 3080 | 1/16/2016 5:04 | 26047 | 1004 | 100.0 | 0.25 | 65185 | 399.980011 | 0.40 | 1 | 399.980011 | 299.989990 | 119.989998 | Eastern Asia | Shanghái | PENDING_PAYMENT | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/19/2016 5:04 | Standard Class |
| 180514 | CASH | 4 | 4 | 40.000000 | 399.980011 | Shipping on time | 0 | 45 | Fishing | Brooklyn | EE. UU. | XXXXXXXXX | Maria | 1005 | Peterson | XXXXXXXXX | Home Office | NY | 1322 Broad Glade | 11207.0 | 7 | Fan Shop | 40.640930 | -73.942711 | Pacific Asia | Shanghái | China | 1005 | 1/16/2016 3:40 | 26043 | 1004 | 0.0 | 0.00 | 65177 | 399.980011 | 0.10 | 1 | 399.980011 | 399.980011 | 40.000000 | Eastern Asia | Shanghái | CLOSED | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/20/2016 3:40 | Standard Class |
| 180515 | DEBIT | 3 | 2 | -613.770019 | 395.980011 | Late delivery | 1 | 45 | Fishing | Bakersfield | EE. UU. | XXXXXXXXX | Ronald | 9141 | Clark | XXXXXXXXX | Corporate | CA | 7330 Broad Apple Moor | 93304.0 | 7 | Fan Shop | 35.362545 | -119.018700 | Pacific Asia | Hirakata | Japón | 9141 | 1/16/2016 1:34 | 26037 | 1004 | 4.0 | 0.01 | 65161 | 399.980011 | -1.55 | 1 | 399.980011 | 395.980011 | -613.770019 | Eastern Asia | Osaka | COMPLETE | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/19/2016 1:34 | Second Class |
| 180516 | TRANSFER | 5 | 4 | 141.110001 | 391.980011 | Late delivery | 1 | 45 | Fishing | Bristol | EE. UU. | XXXXXXXXX | John | 291 | Smith | XXXXXXXXX | Corporate | CT | 97 Burning Landing | 6010.0 | 7 | Fan Shop | 41.629959 | -72.967155 | Pacific Asia | Adelaide | Australia | 291 | 1/15/2016 21:00 | 26024 | 1004 | 8.0 | 0.02 | 65129 | 399.980011 | 0.36 | 1 | 399.980011 | 391.980011 | 141.110001 | Oceania | Australia del Sur | PENDING | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/20/2016 21:00 | Standard Class |
| 180517 | PAYMENT | 3 | 4 | 186.229996 | 387.980011 | Advance shipping | 0 | 45 | Fishing | Caguas | Puerto Rico | XXXXXXXXX | Mary | 2813 | Smith | XXXXXXXXX | Consumer | PR | 2585 Silent Autumn Landing | 725.0 | 7 | Fan Shop | 18.213350 | -66.370575 | Pacific Asia | Adelaide | Australia | 2813 | 1/15/2016 20:18 | 26022 | 1004 | 12.0 | 0.03 | 65126 | 399.980011 | 0.48 | 1 | 399.980011 | 387.980011 | 186.229996 | Oceania | Australia del Sur | PENDING_PAYMENT | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/18/2016 20:18 | Standard Class |
| 180518 | PAYMENT | 4 | 4 | 168.949997 | 383.980011 | Shipping on time | 0 | 45 | Fishing | Caguas | Puerto Rico | XXXXXXXXX | Andrea | 7547 | Ortega | XXXXXXXXX | Consumer | PR | 697 Little Meadow | 725.0 | 7 | Fan Shop | 18.290380 | -66.370613 | Pacific Asia | Nagercoil | India | 7547 | 1/15/2016 18:54 | 26018 | 1004 | 16.0 | 0.04 | 65113 | 399.980011 | 0.44 | 1 | 399.980011 | 383.980011 | 168.949997 | South Asia | Tamil Nadu | PENDING_PAYMENT | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/19/2016 18:54 | Standard Class |